When loading the data flow into a file target, you'll need to provide a folder path where the file produced will be saved. This folder path can be a static value, or a dynamic PQL expression.
Example: Folder Path Variable Expression
In this example, a dynamic PQL expression is provided to point to a shared Parquet folder path to append the value of the given variable to the file path.
The Master Flow
is opened, and the SQL Script node connected to the Data Flow node. The following script is injected into the SQL node (green arrow bellow):
select max(dates) as MaxDate from dates
The results of this expression are then loaded into the variable (blue highlight below).
When the Master Flow runs, the SQL script will return the last date, which will be injected into the variable.
Next, the following expression is given for the shared folder path:
"\\Server1\Sales\Prod"+@Variable_LastDate
When the Data Flow runs, the value of the last date variable will be appended to the folder path:
